[MUSIC] Welcome to Adding Controls, Filters and Visualizations to Reports
in Google Looker Studio. After watching this video,
you will be able add controls to reports, add filters to reports, and add different
types of visualizations to reports. You can add controls to your reports
to make them more interactive. Controls can either modify or
filter the data displayed in a report or provide a way for
you to incorporate user input in a report. That allows users to either input
data directly into a report or select values or items in
the report from a predefined list. Let's look at how you can add controls
to reports using Google Looker Studio. You can add controls from the add
a control button on the toolbar. Controls are split into two types. The top subdivision of the menu
contains controls that you can use to filter data or configure parameter values,
such as drop-down lists, input boxes, sliders, and checkboxes. The second subdivision of the menu
contains controls that you can use to perform specific functions but can't configure parameter values such
as date ranges, data, and buttons. This is an example of
a drop-down list control. This is an example of a slider control. This is an example of a fixed,
sizeless control. And finally,
this is an example of a button control. You can add filters to your report to
allow you to control what data is or isn't displayed in a report. These can be helpful when you want to
temporarily hide some data to focus on other more important data, or just to
focus solely on one aspect of the data. Now well see how to add filters
to reports in looker Studio. Filters are added directly in
the chart's properties pane. In the create filter window,
you build your filter by specifying to include or
exclude selected fields and then specify the condition and
finally the value. You can add further or or
and clauses to your filters. So in this example, we will exclude any data from
the city of Vancouver in our chart. The chart now suppresses
the data from Vancouver. There are many different types of
visualizations you can add to your reports to make them more impactful and
interesting. Let's look at some of the available
visualizations in Looker Studio. First, we'll add another page. When you click add chart in the toolbar,
you see many different options available including some of the more common ones
such as tables, scorecards, bar charts, pie charts, line charts and maps. There are also several other less common
types of charts such as area charts, pivot tables, tree maps,
gauges, and waterfall charts. When you select a chart type, the next thing you need to do is
place it somewhere on the canvas. The chart will then display the data
from its configured data source. You can then resize the chart to suit
your needs by dragging the handles in the corners. You can then change the configuration
of the chart by using the setup tab of the chart's properties pane to modify
which data is referenced by the dimension, location and metric field. For example, Looker Studio has
automatically picked country as the location, but we could change
that to display cities instead. And we can add a metric to be displayed. When you click the view button in
the top right of the page, you switch to Read Only view and see a preview of what
the report would look like to an end user. Simply click the edit button to
switch back to edit mode again. You can use the mouse wheel if
you have one or the plus and minus symbols on the map to zoom in and
out of the map, and you can use your mouse to
drag the map contents around. This can be done in either view or
edit modes. Let's review a few of the other
slightly less common types of charts. Here's an example of a heat map chart. This is a tree map chart. And lastly, this is a waterfall chart. In this video, you learn that you can add
controls to your reports to make them more interactive. You can add filters to your
reports to control what data is or isn't displayed in a report, and
you can add many different types of visualizations to your reports to
make them more engaging and impactful.